CREATE TABLE [dbo].[DnnProduct_PortalAlias]
(
[PortalAliasID] [int] NOT NULL IDENTITY(1, 1),
[PortalID] [int] NOT NULL,
[HTTPAlias] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatedByUserID] [int] NULL,
[CreatedOnDate] [datetime] NULL,
[LastModifiedByUserID] [int] NULL,
[LastModifiedOnDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_PortalAlias] ADD CONSTRAINT [PK_DnnProduct_PortalAlias] PRIMARY KEY CLUSTERED  ([PortalAliasID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_PortalAlias] ADD CONSTRAINT [IX_DnnProduct_PortalAlias] UNIQUE NONCLUSTERED  ([HTTPAlias]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_PortalAlias] ADD CONSTRAINT [FK_DnnProduct_PortalAlias_DnnProduct_Portals] FOREIGN KEY ([PortalID]) REFERENCES [dbo].[DnnProduct_Portals] ([PortalID]) ON DELETE CASCADE
GO
